package com.sheyu.mall.product.dao.category;

import com.sheyu.mall.product.entity.category.CategoryEntity;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * 商品三级分类
 *
 * @author sheyu
 * @email sheyu@XXX.com
 * @date 2020-07-27 12:44:31
 */
@Mapper
public interface CategoryDao extends BaseMapper<CategoryEntity> {

    List<CategoryEntity> selectListBySQL();
    CategoryEntity selectCategoryIdBySQL(@Param("id") Long id);

    void deleteBatchIdsBySQL(List<Long> catIds);

    List<CategoryEntity> selectListByParentCidBySQL();
}
